
USE StudentManagementIntelligent
GO
INSERT INTO Student VALUES('student1','Dinh Tuan Long','male','1988/02/13','Ha Dong, Ha Noi','longdt_b01529@fpt.aptech.ac.vn','0973381329','learning')
INSERT INTO Student VALUES('student2','Nguyen Thi Van Anh','female','1994/8/28','Hoai Duc, Ha Noi','anhntv_b01499@fpt.aptech.ac.vn','01234567899','learning')
INSERT INTO Student VALUES('student3','Pham Thai Binh','male','1994/02/13','Ha Dong, Ha Noi','binhpv_b01529@fpt.aptech.ac.vn','0973381329','learning')
INSERT INTO Student VALUES('student4','Nguyen Cong Hung','male','1996/02/13','Ha Dong, Ha Noi','hungnc_b01529@fpt.aptech.ac.vn','0973381329','learning')
INSERT INTO Student VALUES('student5','Bui Manh Tien','male','1989/02/13','Ha Dong, Ha Noi','tienbm_b01529@fpt.aptech.ac.vn','0973381329','learning')
INSERT INTO Student VALUES('student6','Nguyen Duc Chung','male','1989/02/13','Ha Dong, Ha Noi','chungnd_b01529@fpt.aptech.ac.vn','0973381329','learning')
INSERT INTO Student VALUES('student7','Nguyen Binh Son','male','1988/02/13','Ha Dong, Ha Noi','sonnb_b01529@fpt.aptech.ac.vn','0973381329','learning')
INSERT INTO Student VALUES('student8','Pham Xuan Sang','male','1988/02/13','Ha Dong, Ha Noi','sangpx_b01529@fpt.aptech.ac.vn','0973381329','learning')
INSERT INTO Student VALUES('student9','Nguyen Truong Giang','male','1988/02/13','Ha Dong, Ha Noi','giangnt_b01529@fpt.aptech.ac.vn','0973381329','learning')
INSERT INTO Student VALUES('student10','Vuong Van Tuan','male','1988/02/13','Ha Dong, Ha Noi','tuanvv_b01529@fpt.aptech.ac.vn','0973381329','learning')
INSERT INTO Student VALUES('student11','Bui Anh Tuan','male','1988/02/13','Ha Dong, Ha Noi','tuanba_b01529@fpt.aptech.ac.vn','0973381329','learning')
INSERT INTO Student VALUES('student12','Le Manh Hung','male','1988/02/13','Ha Dong, Ha Noi','hunglm_b01529@fpt.aptech.ac.vn','0973381329','learning')
INSERT INTO Student VALUES('student13','Nguyen The Son','male','1988/02/13','Ha Dong, Ha Noi','sonnt_b01529@fpt.aptech.ac.vn','0973381329','learning')
INSERT INTO Student VALUES('student14','La Van Phi','male','1988/02/13','Ha Dong, Ha Noi','philv_b01529@fpt.aptech.ac.vn','0973381329','learning')
INSERT INTO Student VALUES('student15','Nguyen Van Tiep','male','1988/02/13','Ha Dong, Ha Noi','tiepnv_b01529@fpt.aptech.ac.vn','0973381329','learning')
INSERT INTO Student VALUES('student16','Nguyen Thi Luong','male','1988/02/13','Ha Dong, Ha Noi','luongnt_b01529@fpt.aptech.ac.vn','0973381329','learning')
INSERT INTO Student VALUES('student17','Nguyen Kha Chuong','male','1988/02/13','Ha Dong, Ha Noi','chuongnk_b01529@fpt.aptech.ac.vn','0973381329','learning')
INSERT INTO Student VALUES('student18','Nguyen Huu Dong','male','1988/02/13','Ha Dong, Ha Noi','dongnh_b01529@fpt.aptech.ac.vn','0973381329','learning')
INSERT INTO Student VALUES('student19','Pham Viet Hung','male','1988/02/13','Ha Dong, Ha Noi','hungpv_b01529@fpt.aptech.ac.vn','0973381329','learning')
INSERT INTO Student VALUES('student20','Pham Do Hung','male','1988/02/13','Ha Dong, Ha Noi','hungpd_b01529@fpt.aptech.ac.vn','0973381329','learning')

INSERT INTO Teacher VALUES('giza','123456','Dinh Tuan Long','male','1988/02/13','Ha Dong, Ha Noi','longdt_b01529@fpt.aptech.ac.vn','0973381329','Good')
INSERT INTO Teacher VALUES('anhntv','123456','Nguyen Thi Van Anh','female','1988/02/13','Ha Dong, Ha Noi','longdt_b01529@fpt.aptech.ac.vn','0973381329','Good')
INSERT INTO Teacher VALUES('thidk','123456','Dang Kim Thi','female','1988/02/13','Ha Dong, Ha Noi','longdt_b01529@fpt.aptech.ac.vn','0973381329','Good')
INSERT INTO Teacher VALUES('nhatnk','123456','Nguyen Khac Nhat','male','1988/02/13','Ha Dong, Ha Noi','longdt_b01529@fpt.aptech.ac.vn','0973381329','Good')
INSERT INTO Teacher VALUES('khoanv','123456','Nguyen Viet Khoa','male','1988/02/13','Ha Dong, Ha Noi','longdt_b01529@fpt.aptech.ac.vn','0973381329','Good')

INSERT INTO Manager VALUES('giza','123456','Dinh Tuan Long','male','1988/02/13','Ha Dong, Ha Noi','longdt_b01529@fpt.aptech.ac.vn','0973381329','Good')
INSERT INTO Manager VALUES('anhntv','123456','Nguyen Thi Van Anh','female','1988/02/13','Ha Dong, Ha Noi','longdt_b01529@fpt.aptech.ac.vn','0973381329','Good')
INSERT INTO Manager VALUES('anh','123456','Nguyen Thi Van Anh','female','1988/02/13','Ha Dong, Ha Noi','longdt_b01529@fpt.aptech.ac.vn','0973381329','Good')
 
INSERT INTO [Subject] VALUES('ort3','orientation','Sem 3','Theory',1)
INSERT INTO [Subject] VALUES('wfc1','Windows Forms Programming with C# - I','Sem 3','Theory - Lab',12)
INSERT INTO [Subject] VALUES('wfc2','Windows Forms Programming with C# - II','Sem 3','Theory - Lab',3)
INSERT INTO [Subject] VALUES('web1','Web Programming in ASP.NET - I','Sem 3','Theory - Lab',12)
INSERT INTO [Subject] VALUES('web2','Web Programming in ASP.NET - II','Sem 3','Theory - Lab',7)
INSERT INTO [Subject] VALUES('wcc','Working with Cloud Computing','Sem 3','Theory',3)
INSERT INTO [Subject] VALUES('epj3','eProject3','Sem 3','Theory - Lab',12)

INSERT INTO [Subject] VALUES('ort2','orientation','Sem 2','Theory',1)
INSERT INTO [Subject] VALUES('xml','XML Simplified','Sem 2','Theory',4)
INSERT INTO [Subject] VALUES('ic','Introduction to Cloud computing','Sem 2','Theory',1)
INSERT INTO [Subject] VALUES('jp1','Java Programing 1','Sem 2','Theory - Lab',6)
INSERT INTO [Subject] VALUES('jp2','Java Programming 2','Sem 2','Theory - Lab',8)
INSERT INTO [Subject] VALUES('apj1','Advance Programming in Java 1','Sem 2','Theory - Lab',8)
INSERT INTO [Subject] VALUES('apj2','Advance Programming in Java 2','Sem 2','Theory - Lab',5)
INSERT INTO [Subject] VALUES('pcs','Programming in C#','Sem 2','Theory - Lab',8)
INSERT INTO [Subject] VALUES('epj2','eProject2','Sem 2','Theory - Lab',10)

INSERT INTO [Subject] VALUES('wpsj','Web Programming with Servlet and JSP','Sem 4','Theory - Lab',10)
INSERT INTO [Subject] VALUES('awajs','Architecting Web Applications using JSF and Struts','Sem 4','Theory - Lab',5)
INSERT INTO [Subject] VALUES('ixj','Integrating XML with Java','Sem 4','Theory - Lab',7)
INSERT INTO [Subject] VALUES('cpd','Communication Personality Development','Sem 4','Theory',1)
INSERT INTO [Subject] VALUES('dwsj','Developing Web Services with Java','Sem 4','Theory - Lab',4)
INSERT INTO [Subject] VALUES('deae','Developing Enterprise Components with EJB','Sem 4','Theory - Lab',9)
INSERT INTO [Subject] VALUES('epj4','eProject4','Sem 4','Theory - Lab',10)

INSERT INTO [Subject] VALUES('ort','Orientation','Sem 1','Theory',1)
INSERT INTO [Subject] VALUES('cf','Computing Fundamental','Sem 1','Theory',5)
INSERT INTO [Subject] VALUES('c','Elementary Programming with C','Sem 1','Theory - Lab',12)
INSERT INTO [Subject] VALUES('bdws','Building Dynamic Website and Dreamweaver8.0','Sem 1','Theory - Lab',13)
INSERT INTO [Subject] VALUES('mssql','Database Development in MS SQL Server','Sem 1','Theory - Lab',12)
INSERT INTO [Subject] VALUES('win7','Working with Windows 7','Sem 1','Lab',3)
INSERT INTO [Subject] VALUES('project','Project Sem 1','Sem 1','Theory - Lab',10)
 
-- 18/11
INSERT INTO Class VALUES('c1208i','giza','fat2-c1208i','2012/12/12','2014/12/12','i','theory 1 - lab 1')
INSERT INTO Class VALUES('c1209i','anhntv','fat2-c1209i','2012/12/12','2014/12/12','i','theory 2 - lab 2')
INSERT INTO Class VALUES('c1210i','giza','fat2-c1210i','2012/12/12','2014/12/12','i','theory 1 - lab 1')

INSERT INTO ClassDetail VALUES('c1208i','student1','learning')
INSERT INTO ClassDetail VALUES('c1208i','student2','learning')
INSERT INTO ClassDetail VALUES('c1208i','student3','learning')
INSERT INTO ClassDetail VALUES('c1208i','student4','learning')
INSERT INTO ClassDetail VALUES('c1208i','student5','learning')
INSERT INTO ClassDetail VALUES('c1208i','student6','learning')
INSERT INTO ClassDetail VALUES('c1208i','student7','learning')
INSERT INTO ClassDetail VALUES('c1208i','student8','learning')
INSERT INTO ClassDetail VALUES('c1208i','student9','learning')
INSERT INTO ClassDetail VALUES('c1208i','student10','learning')
INSERT INTO ClassDetail VALUES('c1208i','student11','learning')
INSERT INTO ClassDetail VALUES('c1208i','student12','learning')
INSERT INTO ClassDetail VALUES('c1208i','student13','learning')
INSERT INTO ClassDetail VALUES('c1208i','student14','learning')
INSERT INTO ClassDetail VALUES('c1208i','student15','learning')
INSERT INTO ClassDetail VALUES('c1208i','student16','learning')
INSERT INTO ClassDetail VALUES('c1208i','student17','learning')
INSERT INTO ClassDetail VALUES('c1208i','student18','learning')
INSERT INTO ClassDetail VALUES('c1208i','student19','learning')
INSERT INTO ClassDetail VALUES('c1208i','student20','learning')

INSERT INTO ClassHistory(ClassID,TeacherID,TeachTimeStart,TeachTimeEnd) VALUES('c1208i','anhntv','2012/12/12','2013/8/10')
INSERT INTO ClassHistory(ClassID,TeacherID,TeachTimeStart) VALUES('c1209i','anhntv','2012/12/12')
INSERT INTO ClassHistory(ClassID,TeacherID,TeachTimeStart) VALUES('c1208i','giza','2013/8/10')
INSERT INTO ClassHistory(ClassID,TeacherID,TeachTimeStart) VALUES('c1210i','giza','2012/12/12')
